Manufacturing - Bill of Materials Tables

 

Column Name Column Type Length Default Value Description Enumeration
Id int 4      
RoutingId int 4      
HeaderId int 4      
Sequence int 4      
ComponentId pItemID 24      
CompRevisionNo varchar 3      
LocId pLocID 10      
UOM pUom 5      
UsageType tinyint 1   Quantity Usage Type 0 = Per Assembly, 1 = Fixed Qty, 2 = As Needed
Qty pDecimal 13 0    
ScrapPct pDecimal 13 0    
UnitCost pDecimal 13 0    
CostGroupId nvarchar 6      
DetailType tinyint 1   Component Type 2 = Subassembly, 3 = Stocked Subassembly, 4 = Material, 5 = Byproduct
Backflushed bit 1      
MGID nvarchar 10      
Notes nvarchar max      
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
Id int 4      
AssemblyId pItemID 24      
RevisionNo nvarchar 3      
Description pDescription 255      
EffectiveDateFrom datetime 8      
EffectiveDateThru datetime 8      
DrawingNumber nvarchar 15      
LotSize int 4 -1    
Uom pUom 5      
MrpCode nvarchar 10      
Engineer nvarchar 20      
StockingLevel bit 1 0    
PlanningBill bit 1 0    
Backflushed bit 1 0    
DfltRevYn bit 1 0    
LastUpdated datetime 8      
MGID nvarchar 10      
Instructions nvarchar max      
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
Descr pDescription 255      
HeaderId int

4

      
Id int 4      
MaxQuantity pDecimal 13 0    
Notes nvarchar max      
OperationType tinyint 1   Operation Type 0 = Per Unit, 1 = Subcontract, 2 = Batch, 3 = Run Rate
Step int 4      
SubContractorID pVendorID 10      
YieldPct pDecimal 13      
RtgType tinyint 1   Routing Type 1 = Primary, 2 = Secondary
SubUnitCost pDecimal 13 0    
OperationId nvarchar 10      
WorkCenterId nvarchar 10      
LaborTypeId nvarchar 10      
SetupLaborTypeId nvarchar 10      
MachineGroupId nvarchar 10      
OverlapYn bit 1 0    
Media nvarchar 10      
QueueTime pDecimal 13 0    
QueueTimeIn smallint 2 1 Unit of Time - Queue Time 1 = Hours, 60 = Minutes, 3600 = Seconds
MachSetup pDecimal 13 0    
MachSetupIn smallint 2 1 Unit of Time - Machine Setup Time 1 = Hours, 60 = Minutes, 3600 = Seconds
LaborSetup pDecimal 13 0    
LaborSetupIn smallint 2 1 Unit of Time - Labor Setup Time 1 = Hours, 60 = Minutes, 3600 = Seconds
MachRunTime pDecimal 13 0    
MachRunTimeIn smallint 2 1 Unit of Time - Machine Run Time 1 = Hours, 60 = Minutes, 3600 = Seconds
LaborRunTime pDecimal 13 0    
LaborRunTimeIn smallint 2 1 Unit of Time - Labor Run Time 1 = Hours, 60 = Minutes, 3600 = Seconds
WaitTime pDecimal 13 0    
WaitTimeIn smallint 2 1 Unit of Time - Wait Time 1 = Hours, 60 = Minutes, 3600 = Seconds
MoveTime pDecimal 13 0    
MoveTimeIn smallint 2 1 Unit of Time - Move Time 1 = Hours, 60 = Minutes, 3600 = Seconds
CostGroupId nvarchar 6      
OperatorCount tinyint 1 0    
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
CostGroupID nvarchar 6      
Descr pDescription 255      
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
ECORef int 4      
ECONum pInvoiceNum 15      
Engineer nvarchar 20      
AssemblyId pItemID 24      
CurrRevisionNo nvarchar 3      
NewRevisionNo nvarchar 3      
ECODate datetime 8      
EffectiveDate datetime 8      
TypeRef int 4      
StatusRef int 4      
Other nvarchar 20      
OtherDate datetime 8      
CF xml -1      
ts timestamp 8      
Descr pDescription 255      
Notes nvarchar max      
Column Name Column Type Length Default Value Description Enumeration
StatusRef int 4      
Descr pDescription 255      
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
TypeRef int 4      
Descr pDescription 255      
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
MGID nvarchar 10      
MID nvarchar 10      
CF xml -1      
ts timestamp 8      
Link nvarchar max      
Notes nvarchar max      
Column Name Column Type Length Default Value Description Enumeration
MGID nvarchar 10      
Descr pDescription max      
PrimaryLink nvarchar max      
CF xml -1      
ts timestamp 8